-- show database
SELECT datname FROM pg_database;

-- create database
CREATE DATABASE codenow ENCODING 'UTF8';

-- show tables
SELECT *
FROM pg_catalog.pg_tables
WHERE schemaname != 'pg_catalog' AND 
    schemaname != 'information_schema';


-- show user
select * from User;
select * from Folder;
select * from Project;
select * from File;
